1. Create a user and grant all permissions to the user.
login in as
user: system
psw: ***
---------------------------------------------------------------------------------------------------
SQL> sho user
USER is "SYSTEM"
--------------------------------------------------------------------------------------------------
SQL> create user super1 identified by abcd1;
User created.
-------------------------------------------------------------------------------------------------
* To grant permission to super1 user from system
SQL> grant create cluster, create indextype,
2 create operator, create procedure,
3 create sequence, create session, create synonym,
4 create table, create trigger, create type,
5 create view to super1;
Grant succeeded.
SQL> exit;
--> exit from system user
-------------------------------------------------------------------------------------------------